package com.yun.zf.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yun.zf.common.admin.domain.ZfSchools;
import com.yun.zf.common.admin.dto.community.CommunitySchoolsDto;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author cj
 * @since 2021-05-12
 */
public interface ZfSchoolsMapper extends BaseMapper<ZfSchools> {

    @Select("<script>" +
            " SELECT id,community_id ,`name`, district ,address from zf_schools WHERE community_id=#{communityId} " +
            "</script>")
    public List<CommunitySchoolsDto> getCommunitySchools(Long communityId);
}
